Devin Lee

Overview

About Me
Area of Expertise	Project Management
About Me	Merging Design and Construction
How I Use Smartsheet	Help manage 45 projects per year
Linkedin	https://www.linkedin.com/in/devinclee/

181

Posts

205

Visits

644

Points

Nov 19, 2021

Join Date

Oct 18, 2024

Last Active

Re: Need to add an "OR" function to my formula

Devin Lee

06/04/24

You can nest IF statements together to check for one condition and then the other. =IF([Estimated Project Finish Date]@row > [End Date]@row, 1, IF(AND([End Date]@row <= TODAY(7), [End Date]@row…

1 ·
Re: Approval Workflow

Devin Lee

06/03/24

Create a request approval that triggers on a frequency. For example, I have one that triggers every Wednesday at 10 AM. The condition should be that the checkbox is checked and the approval is either…

1 ·
Re: Formula to check a box if the date in another column is the current month

Devin Lee

06/03/24

It's only checking the month. You will want to check both month and year. =IF(AND(MONTH(Created@row) = MONTH(TODAY()), YEAR(Created@row) = YEAR(TODAY())), 1, 0) =IF(AND(MONTH(Created@row) = MONTH(TOD…

2 ·
Re: Formula to check a box if the date in another column is the current month

Devin Lee

06/03/24

=IF(MONTH(Created@row) = MONTH(TODAY()) - 1, 1, 0)

2 ·
Re: Formula to check a box if the date in another column is the current month

Devin Lee

06/03/24

=IF(MONTH(Created@row) = MONTH(TODAY()), 1, 0)

2 ·